package com.itheima.dao;

import com.itheima.pojo.Order;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface CheckRecordDao {
    List<Order> findAll(@Param("startDate") String startDate,@Param("endDate") String endDate);

    Order findById(int id);

    @Select("select a.address from t_address a,t_order_address oa where oa.order_id = #{id} and oa.address_id = a.id")
    String findAddress(int id);
}
